CreateList_Matching

Creates list of items found in rows, where these rows match a value in another ...

Column2AnString_Unique

Creates list of unique items found in a column, returns string with items ...

Delete_Unwanted_Rows

Delete rows in a different way I used to delete rows by looping through those ...

Most recent in Oracle DB

List the most recently added rows based on a date column.

FilterSheet_1By1 + FilterSheet_Clear

Sets Autofilter in a sheet, and another function to clear Autofilter ...

Add2Column

Quickly adds value to certain column in Excel sheet As usual, you can define ...

all_tab_columns

List all columns in all tables for all schemas in oracle db workbench

Copy formulas

How to copy formulas in VBA code. Learned that the hard way, just like most of ...

Country list in arabic

List of countries codes and names in Arabic, you do not know when you need it ...

Country-list-arabic-master.zip

CountArrayCol

Returns the count of array fields, given the dimension, using UBound ...

CopyRowHeight

Copy row height from row to another Used to fix row heights or merged cells to ...

Rows 2 Cell

Convert items found in a column matching certain material into list in 1 cell ...